package com.kt.appinfo.apinfo.dao;

import com.kt.appinfo.apinfo.pojo.AppInfo;
import org.apache.ibatis.annotations.Param;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

public interface AppInfoMapper {
    int deleteByPrimaryKey(Long id);

    int insert(AppInfo record);

    int insertSelective(AppInfo record);

    AppInfo selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(AppInfo record);

    int updateByPrimaryKey(AppInfo record);
    //query

    public List<AppInfo> getAppInfoList(@Param(value="softwareName")String querySoftwareName,
                                        @Param(value="status")Integer queryStatus,
                                        @Param(value="categoryLevel1")Integer queryCategoryLevel1,
                                        @Param(value="categoryLevel2")Integer queryCategoryLevel2,
                                        @Param(value="categoryLevel3")Integer queryCategoryLevel3,
                                        @Param(value="flatformId")Integer queryFlatformId,
                                        @Param(value="devId")Integer devId,
                                        @Param(value="from")Integer currentPageNo,
                                        @Param(value="pageSize")Integer pageSize)throws Exception;



    public int getAppinfoCount(@RequestParam(value = "softwareName") String querysoftwareName,
                               @RequestParam(value = "status") Integer queryqueryStatus,
                               @RequestParam(value = "categoryLeve11") Integer queryCategoryLeve11,
                               @RequestParam(value = "categoryLeve12") Integer queryCategoryLeve12,
                               @RequestParam(value = "categoryLeve13") Integer queryCategoryLeve13,
                               @RequestParam(value = "flatformId") Integer queryflatformId,
                               @RequestParam(value = "devId") Integer devId) throws Exception;
}